package com.ws.lv.mapper;

import com.ws.lv.bean.Route;
import com.ws.lv.bean.RouteBySelect;
import org.apache.ibatis.annotations.Param;

import java.util.ArrayList;
import java.util.List;

public interface RouteMapper {
    List<Route> selectRouteAll();

    List<Route> selectRoute(RouteBySelect routeBySelect);

    int insertRoute(Route route);

    int softDeleteRoute(int routeId);

    int deleteRoutes(ArrayList<Integer> routeIds);

    Route selectRouteById(int routeId);

    int updateRoute(Route route);

    List<Route> selectRouteBySlideshows();

    List<Route> selectRouteByTypes(int typeId);

    List<Route> selectRouteByThemes(int themeId);

    List<Route> selectRouteByName(String route_name);

    List<Route> selectRoutesByType(int typeId);

    List<Route> selectRoutesBySavaNumberDesc(@Param("route_name")String route_name,@Param("minRoute_price") Integer minRoute_price , @Param("maxRoute_price") Integer maxRoute_price );

    List<Route> selectRoutesByThemeId(int themeId);

    int updateRouteSaveNumber(int routeId);

    int updateRouteSaveNumberMinus(int routeId);

    List<Route> selectRoutesBySupplierId(int supplierId);

    List<Route> selectRoutesBySavaNumberLimits();


}
